- Payment Terms: Enquire
- Course Brochure: Download
- Locations: Bur Dubai - Dubai Al Majaz - Sharjah
- Duration / Course length: 3 months
- Starting Date: Enquire About It
- Timings: Flexible options
Course details
Ministry Approved Certificate
Course Overview
(PL/SQL, Workshop I & Workshop II)
Oracle 10g- Introduction to SQL and PL/SQL
Course Contents:
- Introduction
- Retrieving Data Using the SQL SELECT Statement
- Restricting and Sorting Data
- Using Single Row Functions to Customize Reports
- Reporting Aggregated Data Using the Group Functions
- Displaying Data From Multiple Tables
- Using Sub queries to Solve Queries
- Using the SET Operators
- Manipulating Data
- Using DDL Statements to Create and Manage Tables
- Creating Other Schema Objects
- Managing Objects with Data Dictionary Views
- Controlling User Access
- Generating Reports by Grouping Related Data
- Managing Data in Different Time Zones
- Searching Data Using Advanced Sub queries
- Hierarchical Data Retrieval
- Introduction to PL/SQL Objects
- Procedural Language
- PL/SQL Blocks, Anonymous Blocks and Named Blocks
- Creating PL/SQL Procedures and Functions
- Understanding Triggers
- Packages
Oracle 10g-Administration Workshop I
Course Contents:
- Introduction
- Installing Oracle Database 10g Software
- Create an Oracle Database
- Database interfaces
- Controlling the database
- Storage Structures
- Administering users
- Managing Schema Objects
- Managing Data
- PL/SQL
- Oracle Database Security
- Oracle Net Services
- Oracle Shared Server
- Performance Monitoring
- Proactive Maintenance: Objectives Undo Management
- Monitoring and Resolving Lock Conflicts
- Backup and Recovery Concepts
- Database Backups
- Database Recovery
Oracle 10g-Administration Workshop II
Course Contents:
- Using Globalization Support
- Securing the Oracle Listener
- Configuring Recovery Manager
- Using Recovery Manager
- Diagnostic Sources
- Recovering from non-critical losses
- Database Recovery
- Flashback database
- Recovering from User Errors
- Dealing with Database Corruption
- Automatic Database Management
- Monitoring and Managing Storage
- Automatic Storage Management
- Monitoring and Managing Memory
- Managing Resources
- Automating Tasks with the Scheduler
Course Location
About Aptech Computer Training
Jurassic Institute of Management and Technology is a Learning Solutions Company playing a key role in helping individuals, organizations and nations adapt to the changing requirements of a knowledge-driven world. Jurassic commenced its IT and NON IT Education & Training business in 1993 in UAE. Jurassic is the franchisees of the brand Aptech Computer Education, Arena Multimedia and English Express in UAE. Aptech Computer Education, a division of Aptech Limited has over 3,256 training centers in 56 countries. Arena Multimedia - Global Multimedia Education, leading the way in Multimedia Training has trained over 4,00,000 students.
See all Aptech Computer Training coursesIT, Computing and Technology Related Questions
You may add more courses here,
your list will be saved.
